package pandora.data;

import java.util.Date;
import java.util.List;

import pandora.dto.PriceDTO;
import pandora.dto.ProductDTO;
import pandora.dto.StoreDTO;

public interface IPriceDAO {

	void insertPrice(String nif, String barcode, Integer price);
	
	void invalidPrice(String nif,String barcode);

	List<PriceDTO> selectAllPrices();

	public List<PriceDTO> selectAllCurrentPrices();
	
	List<String> selectAllValidProducts(String nif);
	
	String selectOIDOfPrice(String nif, String barcode);
	
	PriceDTO selectPrice(String nif, String barcode);
	
	 PriceDTO selectPriceStoreProduct(StoreDTO s, ProductDTO p);

	
	//Metodos MRS
	//seleccion de precios de todas las tiendas
	List<PriceDTO> selectAllStoresPricesBetween(Date d1,Date d2, StoreDTO st, ProductDTO p);
	//seleccion de precios de una tienda
	List<PriceDTO> selectAllPricesBetween(String snif,Date d1, Date d2);

	List<PriceDTO> selectPriceByStoreProduct(StoreDTO st, ProductDTO pr);
	List<StoreDTO> selectPriceByStoreProduct(ProductDTO p);

	List<String> selectAllValidProductsBarcode(String nif);
}
